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` = 522009 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522009 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253076,126076,644148,182588,170650,879497,648711,347065,731024,742926,976593,395433,697908,63388,1031109,686081,644538,222494,1042774,469718,630134,257428,56271,654125,245339,100905,1011745,730190,715352,944433,726302,351536,546308,99825,228563,332566,489096,270352,171569,445044,480957,278341,275845,308397,612962,582842,721988,901018,692193,89036,654311,578507,671737,383817,930394,542030,392926,174122,99286,71438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]