SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401418 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401418 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564918,290324,535794,615129,85735,958381,293468,564514,929627,588525,1002490,678374,533967,532723,629175,709324,339481,572745,143137,968554,135221,297358,281936,1025148,678699,705270,567150,669414,543859,429311,223938,340183,528339,651029,906901,1008565,265631,236030,707412,124833,778482,1015675,788513,940673,398914,493419,482173,694304,278229,92616,767894,44933,709582,182069,303969,1019084,664113,449896,600910,821380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]