SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319151 LIMIT 1 [ RunTime:0.002601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319151 [ RunTime:0.008322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207384,194599,187908,421117,94310,480705,584732,463942,406912,1040955,375088,1021236,894832,555243,77576,906756,963329,290223,520150,804144,737888,206262,709978,830602,258252,885343,646081,871089,103762,501995,511605,933644,64440,862475,281292,392033,837372,308928,875920,446480,538358,114523,152843,308528,915468,320118,198119,779906,565302,697821,848375,596566,722639,212519,396105,1034370,154274,667556,49675,315895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]