SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46943 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46943 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383730,669096,346519,1020507,133835,1019060,1023938,277827,140750,184361,693980,482905,136947,891951,288857,541214,457651,345401,406309,674465,395969,714949,16890,77900,899388,543711,1021498,485822,13140,678729,214166,709688,936792,897974,355098,156898,564962,954706,1024180,296854,491093,977642,1035293,300744,286961,779763,503784,838694,754213,707174,201602,301073,562168,400279,541440,695252,205944,568289,664834,34001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]