SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476726 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476726 [ RunTime:0.005684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723660,578379,615082,1037829,538812,879074,844417,167780,1044002,452452,267038,362033,742774,644971,435208,269560,483679,330503,122996,693477,385731,827463,215033,988841,665015,203466,25162,716760,554654,244425,280153,603146,594122,2887,1043064,595647,453837,696075,288586,509804,201844,578593,602800,195374,440201,453553,91659,685394,44017,210878,332618,879293,986791,451375,895022,155752,632658,855767,1003952,121897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]