SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503211 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503211 [ RunTime:0.002993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481707,643778,461110,251642,862560,347725,904934,1006207,1847,560978,655057,203155,826025,654584,420404,594403,403906,395118,491774,197211,772799,39353,391373,959008,429289,297096,511767,120762,710275,182005,34199,653963,318386,917873,1022897,1020421,959633,541271,875413,1040641,118383,637138,162970,839063,440302,167681,249077,369403,130659,428784,245081,317813,741880,432333,360595,161423,73805,528067,641739,614866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]