SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542412 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542412 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125277,959761,1013514,922453,76730,368095,365224,691334,613593,1004841,943616,445141,277703,711097,273760,546873,455724,638653,600124,992582,908358,178140,984883,771831,199234,895893,831684,762197,269905,130041,411883,570716,728540,272195,780411,666637,719427,539206,719154,816796,593389,122569,551552,164683,1692,71019,941724,862593,133345,1043042,347020,927024,624200,501467,476492,341115,363670,24644,897044,492717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]