SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199810 LIMIT 1 [ RunTime:0.002294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199810 [ RunTime:0.008263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516194,108996,252730,709867,27662,727355,656665,195366,542880,79228,109844,110587,708291,73183,676019,240191,374206,468416,664127,19522,196933,656226,121453,530792,248132,139403,365608,335016,859332,156370,782781,808231,371200,876074,6310,351809,407372,384920,633171,127691,248104,949845,581055,38557,830672,566746,387424,529684,631682,286828,555500,1014192,284221,238452,33260,321649,356268,893453,1036264,1031229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]