SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409500 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409500 [ RunTime:0.004242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505103,365919,544859,495326,277689,708344,769669,67298,394178,49123,610988,439743,186966,310598,792426,177048,770499,288883,848857,819979,694099,12813,982623,237685,569092,408801,129463,394619,737616,209411,454928,207219,895974,448111,347615,907512,481991,947761,358471,368692,283000,655847,153995,882581,435062,130303,813054,926038,299636,161963,996873,1011573,167935,808618,788517,216291,763346,323106,946259,1007908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]