SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532815 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532815 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853627,803185,788055,782290,795833,2937,149074,490091,895051,226529,873843,822193,828418,69778,906020,570442,853756,984630,764574,374757,257272,244672,755108,828791,210415,295117,803294,525965,464730,552667,341703,9629,637886,206942,915962,269504,718041,404592,832732,355068,572451,992309,276623,333251,125099,259072,740627,528049,392868,429269,483577,133396,539414,203474,770069,288069,5693,217783,266590,712302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]