SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303864 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303864 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433746,834855,9175,980525,282829,166584,436148,364204,873361,241656,468412,212064,182156,59246,108682,1040712,665779,493787,723023,537308,457167,743188,465822,261934,6102,94516,473611,103471,417242,305610,699223,128390,975950,574306,152671,588129,1043517,120120,1034298,1031480,323657,412008,1036930,383667,954195,580304,625484,994894,660888,219418,861862,333776,493317,847530,767368,763987,70108,885733,877710,115655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]