SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250007 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250007 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553897,931432,921584,667121,369551,718581,402003,287361,749658,304455,438129,937774,657699,1000550,786583,761945,973811,226663,274135,875628,966332,133991,181399,317074,673464,983863,254153,351737,40205,423656,772800,568720,170452,295612,784233,937059,268803,501993,396598,897729,768292,163666,620614,196095,279917,355998,771053,782654,879764,999028,160827,1025872,898568,213146,377927,581273,707638,966871,605530,552634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]