SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106095 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106095 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405332,887358,258285,821913,981020,906640,727662,488785,245486,213513,771,441432,239794,897498,42713,1042477,538240,527386,660520,61984,609886,514500,762470,831541,48531,939341,378844,1015757,1005619,367224,947766,414262,408171,29172,319039,1003546,366078,268597,7293,384922,763832,709700,108682,250223,729927,640872,960716,387886,267064,98156,233996,940028,719856,386089,597842,64794,698996,532357,1034132,919359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]