SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417947 LIMIT 1 [ RunTime:0.003154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417947 [ RunTime:0.008713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367132,535559,377673,208890,662169,345990,542946,126499,691966,688138,908965,484700,477493,118417,218914,570573,924996,392845,614474,606844,874927,786521,24032,790062,564066,439872,908955,815694,654626,602735,779260,653465,1021983,986,243665,57811,830668,253636,662756,815382,919648,887443,1000353,739118,534823,169780,349194,774974,318746,406939,838210,842221,446768,736109,955697,137349,615668,968432,125027,673560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001446s ]