SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513528 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513528 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788707,150347,456364,628620,685063,881528,216733,108005,544970,957699,174832,723152,516660,243946,851727,519448,87513,802660,277213,501951,938951,948816,415046,220620,196028,626798,205806,849365,211518,985858,526777,161176,634597,571012,34903,1045572,544336,62197,163748,368439,424989,627973,845045,226628,624092,798579,368830,888176,31885,902154,1014870,66942,810938,718494,141033,769518,585676,52605,29730,41814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]