SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268410 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268410 [ RunTime:0.003156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708249,101713,544222,404530,500346,791723,417559,116723,128956,583653,52547,163870,786547,8690,477577,388123,318519,748128,327964,677814,514303,153010,353500,892092,424375,887761,398896,265126,915966,312796,220680,772368,930605,113245,670776,834959,216443,669278,917758,636365,6872,143750,424127,788153,531384,386963,316419,1021535,718771,202950,391858,732125,169235,789220,531008,442146,1042854,387113,949170,120870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]