SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426813 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426813 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133842,717938,509027,44307,1012331,1012605,1023724,153031,962144,383635,302663,46482,212234,954597,796856,10178,499688,177506,285026,268021,794092,622820,732554,683803,517914,678933,696801,335613,18149,685727,276693,474527,40433,141263,565810,159709,186392,332742,1673,754097,578177,427840,247833,897913,439429,250090,703998,200862,236766,390373,126586,685887,680421,821570,1003207,192901,958646,1004787,184435,462086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]