SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43180 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43180 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393984,106422,739563,688150,131790,953097,992102,947103,115088,394354,872766,255781,204008,121426,305672,812304,293316,781507,796788,936804,356964,214956,974954,769345,848927,58091,654556,530667,123870,676963,473891,917202,748712,786293,184556,216026,669582,764167,851730,435380,863918,751379,878749,344316,105115,396163,229818,691106,736890,186276,74199,875476,729641,1034039,374351,232517,808022,328308,1003083,968917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]