SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200634 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200634 [ RunTime:0.002306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027641,161098,358458,368824,187369,536702,111794,145310,294466,24844,426940,681247,792096,689660,770691,620284,322087,11962,670942,646874,738979,741103,718517,904176,330032,1001649,315900,921952,551058,563264,1042175,661695,892487,819556,458134,1042800,384452,260291,681027,915907,900603,818665,747760,200349,262771,75698,818343,928258,259281,580647,168586,999791,234027,548942,45556,697990,716913,1005633,1014350,769789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]