SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551663 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551663 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125737,1021212,767499,564246,543705,216406,1041588,980670,774831,599493,610630,127816,595788,868938,880754,242783,866708,492417,449512,272364,566486,537961,984879,416992,135532,346843,413257,185826,74269,419269,174160,869701,1015535,419882,811961,364322,673330,977943,1020266,460545,809648,378475,395318,362882,313576,633704,1041462,302689,390367,776858,659630,344163,44899,779580,221807,323195,676500,475409,470741,405659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]