SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042843 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042843 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872044,957024,513679,331299,1038695,516883,113583,807685,300915,858873,548541,808731,211702,790190,579389,111830,832239,626944,738012,387456,414453,687094,889795,865409,284049,575013,698594,965712,157142,394174,258446,430566,274022,1033921,837257,1011419,698586,489711,469808,587110,421116,910687,281714,440981,9214,228140,566308,31434,406205,236759,956872,864513,1045018,689388,228145,862191,357388,88334,40783,454452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]