SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401311 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401311 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576041,686794,260717,881956,874290,213169,1001889,612380,122498,686224,440172,336495,445430,846745,914847,5653,42104,695815,48562,634333,407013,192139,217819,465894,1017068,317108,1019401,517019,364059,28197,699340,760964,61103,177478,97118,138864,832442,634438,413931,582722,37693,5069,843593,75503,576382,212356,581278,700867,258779,1034942,212964,610260,574219,612754,540369,915650,775439,377841,858118,1033844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]