SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505741 LIMIT 1 [ RunTime:0.001164s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505741 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738081,836959,75880,135716,1022984,864077,727383,790801,457547,715469,539605,498445,786537,621555,273208,824200,256631,39896,462338,454460,130154,143821,526829,784359,672021,532800,184129,201650,1047482,197776,1006029,945883,711935,1006169,215296,704445,709663,998240,910739,520641,878159,781236,993789,730721,151111,474766,720320,77431,666294,955279,201171,670417,414057,533952,358816,681052,331818,495095,977747,612511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001222s ]