SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891753 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891753 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767751,200442,86450,76050,630815,1038177,119360,795929,438292,336897,24199,125003,454026,158502,872923,985079,602555,762945,587406,853777,814423,850836,986228,144167,850506,215126,306294,70598,639796,534838,266182,66175,449017,299890,404379,542828,473753,150727,1040691,654599,46350,775209,348899,126334,270236,908019,380368,789263,240578,1025158,330798,589136,367475,497202,371545,361380,318371,306080,821915,749198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001310s ]