SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381909 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381909 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685136,421268,405857,1031068,340312,1031635,539629,412246,313465,218134,612861,415503,52090,115042,73372,2684,988021,320397,412643,734958,204451,894598,121134,841203,1034517,77477,339942,564493,862255,919833,1002490,703147,754667,333540,41896,952204,272849,1029229,737617,1019958,243350,172315,505879,628432,671343,781627,363234,920268,258342,1018679,40620,736998,985643,685593,646320,343517,339032,1035972,193230,384540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]