SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479207 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479207 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903067,99206,142230,80014,167205,157914,631065,565874,991000,10294,986113,159383,471457,340757,435954,466089,390971,915770,747896,429540,595125,708704,89122,360679,771125,678109,669014,870216,709591,704242,771427,919840,866832,332944,165355,525014,1045901,778422,801587,583188,164279,869803,760006,555962,716141,109523,308365,689504,964444,81219,250684,332953,405426,644002,867690,64037,391434,996455,257967,77437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]