SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451882 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451882 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006263,578152,820390,648930,536084,315988,437338,178669,172530,683143,6124,346116,578695,928976,999920,298467,778549,785314,1031717,647126,570533,484884,272396,214567,488366,652916,340220,401429,312808,339118,237453,293601,1022679,319146,473361,435663,503500,943916,158561,344765,805911,69817,645256,661903,401001,953812,1043529,499882,537031,680933,965968,94034,1002091,162116,200932,84445,877472,770670,453364,172993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]