SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044618 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044618 [ RunTime:0.002790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859156,210690,641742,114492,83286,387519,925008,1022213,714059,264728,320353,159832,1014995,150279,616445,161465,250573,221014,204191,258283,706680,242810,515468,328629,84558,787301,371780,873146,5807,114659,572646,77540,72211,982269,837359,514720,636506,535921,393902,674426,798773,968519,296959,3322,728953,531735,889696,683876,588352,492168,271968,858724,937196,610105,742725,826254,968079,620342,128123,1001448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]