SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418179 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418179 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524956,188997,81795,673023,382115,984030,465312,111539,1038780,212940,298258,319675,803687,1025091,608714,246183,773745,656232,359881,336823,466414,149217,137281,122907,682332,853132,670511,509275,105153,283031,931174,247985,143115,912625,81580,823173,626472,758739,925062,289865,515814,1039662,897848,14982,894792,492284,258734,350659,509813,445559,743382,126896,451004,950161,96296,90785,365682,850657,311640,763302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]