SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382511 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382511 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103732,291804,1000418,336175,384705,172500,86507,41970,36812,396343,256177,344308,925319,856636,601866,56814,335645,865300,123215,113982,492710,837691,912762,393586,253694,729054,206625,1001097,163227,649785,295589,844271,207120,322001,848513,120293,280088,844693,766948,79426,264406,758243,85197,978874,954775,671929,496554,739479,499965,156710,426533,878665,1013868,968631,748461,1010046,468331,187159,810042,645535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]