SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515499 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515499 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920020,205411,570266,857805,269543,873068,331538,437031,95011,255182,1018128,85358,814975,1003147,651439,64868,757903,1021254,980868,971392,711838,45988,864413,716869,833013,690596,495340,593112,137591,777197,858171,994705,175863,609865,541539,254510,308851,264861,165411,194978,357375,1042241,735255,748716,420167,152842,668359,770513,510836,526347,138404,1044904,738630,628059,55202,499373,464308,727819,260342,384482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]