SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403652 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403652 [ RunTime:0.002352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108232,315794,381518,637481,374477,240050,528329,806447,342021,375000,457496,125566,398944,828724,466249,152811,702281,540400,569818,480070,105241,1011527,815885,811401,428436,740675,487493,276993,172194,533936,1041182,416923,552477,659006,507590,662909,348954,585772,28831,628100,523139,572165,356190,1017084,382178,1032336,698623,321956,303613,877605,174264,110572,219041,511657,418473,767206,696344,279731,378134,385881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]