SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036702 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036702 [ RunTime:0.002971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489573,554022,1023234,521766,290207,986829,697834,253217,225789,355431,76476,126214,951979,201316,22327,609141,875372,253110,500568,333900,206539,928940,530147,434705,364345,39528,751244,719595,907795,312634,933397,72484,332778,621337,1017351,671933,339493,835782,90139,163345,176070,20047,368162,321564,258007,461263,503148,222299,771799,992498,599599,1011598,663656,777297,165126,453087,367071,218730,869911,337635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]