SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004963s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284420 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284420 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759383,598221,851077,193060,1023609,581188,238167,160148,934608,84272,809076,1022859,192182,494146,150576,522259,628979,361568,1021097,506617,528390,985318,611404,360478,421762,261299,25462,342004,182903,1002347,158355,525422,579033,358944,552545,447770,961148,37661,104124,755105,890752,279452,479713,92316,295327,839384,806203,90042,776515,900390,933018,585430,937474,907380,44218,953624,590068,57075,139467,149962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]