SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148553 LIMIT 1 [ RunTime:0.001440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148553 [ RunTime:0.007610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033252,574023,366641,689383,509105,357597,142410,222570,402792,761736,197555,966106,575538,950430,120500,939880,769562,547348,336379,1021952,286878,49821,364847,126308,684982,162397,54877,404836,425804,864498,508537,347496,1032292,629479,471039,112037,807740,860413,38717,309530,435436,787553,321485,171177,740915,975026,548287,974854,801803,308235,476308,520716,313224,906615,461318,597947,418755,284644,919528,144037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001706s ]