SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387972 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387972 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452224,1017870,791296,128538,22907,746667,534465,342713,453994,15091,902244,240287,264187,942026,750949,112993,928301,423819,624992,763325,187695,782929,244317,538814,329612,963018,687045,942099,600564,1045247,347458,199542,398514,827770,977009,678970,332061,308854,16499,358656,398911,273820,66753,789001,34940,963940,137944,339021,33680,418284,409869,42570,313109,1008658,618485,549389,906792,661465,962011,975678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]