SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814216 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814216 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629683,406108,787610,100691,815682,349188,95282,765194,178804,429896,1027658,100162,461066,27554,524858,327550,906653,570495,492953,1044542,167903,411144,261650,822273,46963,40641,373553,194268,25749,372148,834091,285903,1000330,114199,773392,586693,448519,921917,419676,916890,487345,378322,346394,83233,672727,371675,982676,928409,697373,1045693,799483,905669,958272,238621,700149,787420,528869,758630,60974,271912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]