SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80371 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80371 [ RunTime:0.007528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630408,438466,483222,637711,437163,855869,871046,1046438,130091,578019,261944,563522,481272,8368,175894,348716,759541,262627,694039,1026931,124120,595964,216559,640171,287470,940607,199556,20896,352920,675280,811724,407031,100704,979269,232386,755214,345564,276523,128117,685675,785299,177849,700339,269498,574314,913952,574143,887107,348543,863737,861848,949893,1030672,18748,330325,69486,41215,1037498,980372,661908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]