SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10202 LIMIT 1 [ RunTime:0.002548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10202 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020022,410221,480564,333168,485768,756904,932732,747761,938787,475743,656252,492104,775123,111773,885806,662999,1005811,937521,589569,783760,744009,116169,89861,655036,115018,941790,17670,138130,467910,595835,848464,160458,880263,635456,783643,545411,476164,147970,339365,1030380,669591,81882,601611,970996,850125,86829,498326,1010213,183935,200027,40932,22289,757348,476184,691091,100792,297209,141057,421955,975601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]