SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413980 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413980 [ RunTime:0.003553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249971,1025859,670920,120921,448366,23636,444122,438746,508316,1011659,949263,755482,1014953,799216,934036,411682,658334,610494,68548,382467,492943,493114,838466,147641,433511,872105,774348,655564,50380,252458,349064,779474,264266,772722,70934,565361,645515,364129,117833,363961,721715,167713,275913,22840,1010874,506008,409859,1048492,739966,842119,315651,321311,766057,26834,322562,166223,987941,451733,915049,32958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]