SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410915 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410915 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543120,189537,578836,1045741,670646,206171,266223,736297,685986,212121,359669,692641,382437,798711,90831,237382,414199,661850,785749,480019,600648,385030,766723,319176,716689,423982,1037659,794789,271818,430682,31234,425534,896009,815843,503118,530054,910674,383303,94572,1017924,272551,455378,455245,280746,891907,767047,854181,613200,121959,602985,76339,738308,864695,604721,1040042,91665,427788,124735,657921,805737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]