SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565612 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565612 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289549,594805,1003229,605462,805994,706714,984444,907443,583977,598173,77589,646879,715169,55861,445892,328235,202838,1022075,1034956,1023338,367070,128518,138449,604935,779577,725017,626656,281897,890578,129844,28177,91127,641609,853271,378184,629123,444878,237130,438298,745403,249192,375512,447378,790226,415117,1046528,194654,246838,274305,127911,427090,931279,111701,373385,696907,813294,24676,207756,1025924,886238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]