SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461211 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461211 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234795,1046102,38721,276920,623804,447023,455542,954149,896485,76113,260261,448036,817548,641790,738112,909677,899676,410757,97780,1029880,528249,394582,227152,2219,852553,491914,130528,451708,1014537,196288,389618,3321,618172,621572,1002507,868568,304643,1001592,232123,193771,1008432,61136,160259,241388,405616,261876,100457,438530,964785,578336,284184,686271,147730,569270,957063,757045,435165,753686,296122,22482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]