SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303023 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303023 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250137,392952,594420,771870,724569,640225,206720,649890,655417,175933,133878,478330,332488,743055,391578,840484,869640,408275,2639,627880,74224,755591,717197,90824,21938,1035848,126798,120065,695512,497039,824836,469659,793422,494455,811347,554100,403173,939542,308676,392943,240771,369912,126567,896427,537096,213753,945481,443969,493314,426498,928601,543221,859767,438265,294699,885427,396002,336934,552136,975182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]