SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431692 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431692 [ RunTime:0.005443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205644,485161,524674,108321,464324,919711,332600,153517,1019847,684204,291481,356267,524588,734749,127614,842163,962667,805275,287469,318955,31201,556028,412313,718509,910477,731035,828934,173725,575155,773442,994872,299979,106697,405689,64295,322036,285056,142158,551939,446678,529882,761254,148009,847047,199506,616653,338457,82320,582257,113015,1046531,241543,451376,131084,204215,1015776,100937,773186,639546,521244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]