SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515075 LIMIT 1 [ RunTime:0.001921s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515075 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801815,690019,523519,673742,279493,787657,703282,931314,783201,399736,872642,238680,770629,943536,290434,538029,1006640,55602,888767,691042,891334,344382,937477,682207,733178,469095,101943,168196,578824,489854,807175,628952,901752,952521,29435,158388,583949,281170,942661,84734,995164,318051,704407,359654,307131,1002175,6804,882887,345997,417260,609690,564667,936176,614797,725826,751297,613566,386633,362121,389470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]