SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043319 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043319 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129422,352510,927749,670980,12896,741805,998612,344272,226778,64589,76490,619289,961441,1043201,126416,900601,83927,309000,2509,264276,1034402,613090,642114,564955,408216,295883,680297,463605,118373,304840,277825,241337,92103,980122,702366,969394,147444,651654,389524,306936,491902,181466,145916,968182,799865,777474,798,554274,18498,949523,637454,581687,199748,317693,402735,557815,875936,400751,518563,417091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]