SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382504 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382504 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597660,277352,1028256,586273,986747,37908,640491,174618,99226,798722,269033,801358,112801,707502,69535,683202,448586,972222,849865,526168,81325,300421,684978,202274,384548,781199,888457,258500,216734,497437,1040769,897135,479250,74836,184134,392976,826668,681584,953778,721893,43443,1034565,101182,446606,971801,97588,236360,260065,25045,286920,85886,188754,565285,216525,724165,938134,156069,299863,541509,114710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001065s ]