SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53485 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53485 [ RunTime:0.003206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231823,997470,682374,491072,120159,484954,776201,839127,388490,944454,832025,920121,644298,707462,610302,811577,679438,300596,142551,2111,500214,697548,120637,871941,964236,339056,232047,281751,197881,726237,531097,399435,244715,751459,88346,65438,586663,30849,7689,17918,25376,873720,977602,752147,287516,614101,383159,85904,624864,361690,626467,611488,181886,54679,242886,947719,142640,576492,158668,663370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]