SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458004 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458004 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19232,292574,390237,348528,231928,474217,773852,375607,334266,69493,1034234,389513,276452,674067,565016,249325,430693,494145,839789,59417,474241,170513,705120,17460,196209,714650,800970,699171,706162,598469,994694,682358,214721,912691,893304,111133,531272,143983,514986,706886,1013683,353373,430212,306044,369511,573281,751110,793575,396937,32323,31750,19212,826778,95631,257076,145616,449120,562537,131447,682989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]