SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405419 LIMIT 1 [ RunTime:0.000701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405419 [ RunTime:0.003015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448284,152456,207604,628297,617237,1018570,837407,870987,841435,481041,666778,32553,82556,974734,195946,352619,615503,834077,116827,669807,333585,892181,990754,362727,888305,206120,570324,403438,904127,588937,913073,817154,298177,65102,1001696,489511,448017,91514,544223,38429,435110,529137,695522,491129,383697,508923,630924,62336,1031351,950050,93305,1012047,959036,236537,187149,928082,893167,27600,376081,387490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]