SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556630 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556630 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162589,301802,290733,436659,806255,198081,135863,737656,840044,589110,662089,472071,879223,680232,395984,495898,788754,341446,761106,581349,75424,737320,203578,488088,133680,83390,191518,898962,1041772,563132,66647,13940,695230,375373,691786,381223,427281,388872,967166,331675,521076,509356,967680,755790,918502,745855,498230,881444,763579,293856,996825,377468,1040722,174852,989882,406356,709723,513106,402685,456686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]