SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316134 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316134 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477080,743180,745898,1011645,909409,280242,964774,975751,78126,623800,977501,1001838,788250,511384,354281,737970,165140,974292,391846,471113,889036,897566,796693,777147,920894,161255,6417,273192,972470,22645,948231,191642,779036,312162,639320,258006,367571,363527,769695,428961,3120,534006,262157,554272,977500,894949,850500,931178,498541,187900,154346,771294,30426,933952,149271,787393,489652,315807,658646,137580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]