SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54685 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54685 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009379,103625,115604,139260,283507,133657,745333,707433,327979,204914,122237,233046,784467,39351,1024553,171869,592862,724072,794739,425360,231246,826750,728625,123654,547872,518612,724261,35720,138320,98180,272555,813780,687856,490132,704318,572589,1021558,276734,899340,843840,647598,253378,368203,454905,336697,450651,327080,886846,570714,714487,635211,753133,391685,276230,582620,386952,1033397,723138,619922,448843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]