SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509377 LIMIT 1 [ RunTime:0.002137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509377 [ RunTime:0.005495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007010,97291,1043702,473445,46981,44105,935872,966494,412885,699694,233631,972154,1014987,464345,705434,582034,184388,615165,856486,448945,902605,874408,1017452,238934,128646,1001854,262348,244083,884057,15664,146007,572003,591515,559936,192997,676576,478949,961158,235209,114394,1024236,158075,787955,814710,51037,431865,857547,598216,177491,421104,674008,249015,67257,295828,949932,448193,135371,166983,815619,307021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509377 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509377 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]