SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416781 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416781 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39102,558787,460950,68077,536581,82358,497455,88850,787476,564065,349376,76841,400471,727276,893588,991939,804860,894215,309878,262011,553783,586369,320949,823505,304411,838152,426201,563948,265141,874525,938622,516148,717527,693772,398267,39892,491269,1011966,385411,1042357,300807,1038253,890135,783352,864007,898442,341205,965209,389729,717259,713696,915461,212326,560467,410422,499079,404488,370027,145872,785833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]