SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40773 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40773 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468951,1039073,484034,628799,464086,813048,591121,1014411,598476,184572,564134,386004,791960,16791,461913,776585,1041460,174174,88387,1043261,191445,767700,286456,1041628,485797,428437,335483,730898,884501,267335,117050,62454,556174,784584,821190,380868,87352,528332,448274,477189,168726,124257,880793,937025,417931,231026,713523,354979,1043076,602908,871540,483941,681346,685531,295940,110073,1031132,1014469,798919,176772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001972s ]