SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587209 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587209 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477022,183161,273763,933102,428209,274608,241258,406940,91398,939926,989459,193027,548144,1030170,534138,225856,874708,603305,436773,614610,10435,452271,248135,781069,6726,940738,198282,360904,265960,1006556,859056,1002334,820946,192960,63439,547828,977519,693656,165543,908701,396691,242085,985091,1005220,159863,338684,897626,657555,283423,642314,367881,532315,1019758,359242,847138,1012562,926017,29493,901190,250493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]