SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155534 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155534 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043906,817656,776413,905699,723704,463987,116990,631780,39811,715747,146623,737060,818403,219694,824473,929059,30419,580311,206502,169353,284451,522588,997219,593062,1040816,97245,472712,361967,260641,758987,385801,738430,18883,351259,906901,733108,645357,685425,147602,312861,964367,550778,439397,104194,501237,202339,414799,531593,462966,223056,536171,168795,925578,793385,66353,509197,401279,774,43126,337283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]