SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35401 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35401 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598237,737075,591274,96651,924839,111674,411204,209517,379356,1023853,136048,628393,703215,618512,1029261,404820,860338,27977,242238,358427,619247,564631,103732,747068,110677,666386,753689,1047440,724969,890536,612088,575174,446659,544544,28154,299935,858247,415847,437473,1021038,404995,59187,113638,912522,832394,112617,996660,574209,380086,441057,933440,663020,690535,363903,968931,598488,185517,800426,238767,752492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]