SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486028 LIMIT 1 [ RunTime:0.001547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486028 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492019,106617,375872,590374,716448,511460,110845,898053,802678,7029,71280,1005818,744785,159053,483631,975394,314547,682285,623350,456000,545921,636915,51627,34712,467276,905549,527310,33495,57974,869426,213321,926980,815886,681269,451859,201512,15058,451720,103515,669086,822909,387811,959308,120685,728528,95236,821628,837190,976079,27,195684,834679,230344,649340,343017,139551,1043360,620025,225601,527159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]