SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427708 LIMIT 1 [ RunTime:0.002418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427708 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469560,574075,987575,24680,426839,591827,665797,375419,761424,20660,560955,788297,17282,949844,462661,345622,117431,551352,135563,724396,263297,772848,307591,698626,786115,651341,872103,775868,748767,80239,414191,468460,800119,565410,430947,36789,798935,1008971,132958,288240,528421,686862,201026,195110,600786,782777,358962,555394,8842,612152,759766,1018397,743628,178905,770352,70178,2418,991310,842517,537838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]