SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413901 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413901 [ RunTime:0.002704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17079,352814,341292,961135,400314,1030149,182768,131805,937446,450839,585785,943301,435597,759667,295330,806259,91950,515370,866080,288233,397711,488732,644001,582597,406663,607384,946869,990640,497731,510768,230880,966212,659394,806742,536868,541455,1003704,115179,1037879,293329,595708,12096,982939,448870,140222,768042,938371,960561,641328,974846,359257,37834,277298,855568,759428,210912,894029,632630,719708,431316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]