SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432104 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432104 [ RunTime:0.005042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54961,774913,228700,214759,223615,315840,200459,116029,43056,590224,397335,531451,927267,846179,317800,790488,371844,695810,1006691,87813,607016,255627,927982,531553,592941,798803,86737,626333,833566,355933,157118,652947,649649,148800,843797,1010468,243266,166238,931391,247042,408529,853670,1000095,473151,700938,742011,888257,741535,619541,642281,716179,159374,545444,478605,902163,467504,952464,429828,625641,55528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]