SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 21328 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 21328 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487480,362050,258393,1044796,54736,816375,315048,338670,568314,851035,941519,338198,637313,858566,344621,875603,1046190,819583,941083,565262,814852,689513,769907,134934,24580,753124,361855,491318,35086,272472,104836,519623,11763,752123,604396,569246,381519,591730,765590,875699,371250,1036231,137253,471972,921145,320258,395094,303705,788675,833051,993,1005886,140138,359610,1041241,341917,219844,758234,209139,195223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 21328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 21328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]